﻿CREATE TABLE [dbo].[RecommendationIssueType] (
    [RecommendationId] INT NOT NULL,
    [IssueTypeId]      INT NOT NULL,
    [Order]            INT NULL,
    CONSTRAINT [PK_RecommendationIssueType] PRIMARY KEY CLUSTERED ([RecommendationId] ASC, [IssueTypeId] ASC),
    CONSTRAINT [FK_RecommendationIssueType_IssueType] FOREIGN KEY ([IssueTypeId]) REFERENCES [dbo].[IssueType] ([IssueTypeId]),
    CONSTRAINT [FK_RecommendationIssueType_Recommendation] FOREIGN KEY ([RecommendationId]) REFERENCES [dbo].[Recommendation] ([RecommendationId])
);

